IndustryDefinition

V8 Message Definiton

This table contains the definitions of ind (00), sub (0000), grp (000000), and nbr (00000000) numeric codes are used in the SpiderRock platform.

METADATA

Attribute	Value
Topic	4335-product-definition
MLink Token	SystemData
Product	SRAnalytics
accessType	SELECT

Table Definition

Field	Type	Key	Default Value	Comment
code	INT	PRI	0
indType	enum - IndType		'None'
name	TINYTEXT		''
timestamp	DATETIME(6)		'1900-01-01 00:00:00.000000'	record update timestamp

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
code	1

CREATE TABLE EXAMPLE QUERY

CREATE TABLE `SRAnalytics`.`MsgIndustryDefinition` (
    `code` INT NOT NULL DEFAULT 0,
    `indType` ENUM('None','Ind','Sub','Grp','Nbr') NOT NULL DEFAULT 'None',
    `name` TINYTEXT NOT NULL DEFAULT '',
    `timestamp` DATETIME(6) NOT NULL DEFAULT '1900-01-01 00:00:00.000000' COMMENT 'record update timestamp',
    PRIMARY KEY USING HASH (`code`)
) ENGINE=SRSE DEFAULT CHARSET=LATIN1 COMMENT='This table contains the definitions of ind (00), sub (0000), grp (000000), and nbr (00000000) numeric codes are used in the SpiderRock platform.';

SELECT TABLE EXAMPLE QUERY

SELECT
    `code`,
    `indType`,
    `name`,
    `timestamp`
FROM `SRAnalytics`.`MsgIndustryDefinition`
WHERE 
    /* Replace with a INT */ 
    `code` = 5;

Doc Columns Query

SELECT * FROM SRAnalytics.doccolumns WHERE TABLE_NAME='IndustryDefinition' ORDER BY ordinal_position ASC;